The head of Marketing believes that maximizing the number of annual members will be key to future growth.
Moreno has set a clear goal: Design marketing strategies aimed at converting casual riders into annual members.
Marketing team are interested in analyzing the Cyclistic historical bike trip data to identify trends
The question to answer in this Analysis is: How do annual members and casual riders use Cyclistic bikes differently?
Also recommendations will be provided based on the finding of this Analysis
Description of the dataset
| No. | Column | Description | Data Type | Category |
|---|---|---|---|---|
| 1 | Ride_Id | Customer Unique ID | String | Nominal |
| 2 | Rideable_Type | The type of bike customer used for the trip | String | Nominal |
| 3 | Started_At | The date and time when the trip started | DateTime | Discrete |
| 4 | Ended_At | The date and time when the trip ended | DateTime | Discrete |
| 5 | Start_Station_Name | Name of the station where the trip started | String | Nominal |
| 6 | Start_Station_Id | ID of the station where the trip started | String | Nominal |
| 7 | End_Station_Name | Name of the station where the trip ended | String | Nominal |
| 8 | End_Station_Id | ID of the station where the trip ended | String | Nominal |
| 9 | Start_Lat | Latitude value where the trip have started expressed in decimal degrees | Float | Contiuous |
| 10 | Start_Lng | Longitude value where the trip have started expressed in decimal degrees | Float | Contiuous |
| 11 | End_Lat | Latitude value where the trip have ended expressed in decimal degrees | Float | Contiuous |
| 12 | End_Lng | Longitude value where the trip have ended expressed in decimal degrees | Float | Contiuous |
| 13 | Member_Casual | Classification of Customers: Customers who purchase single-ride or full-day passes are referred to as casual. Customers who purchase annual memberships referred to as members | String | Nominal |
Time-Related Recommendation: ensuring the demand for bicycles are met and having availability also during peak times:
Location Related Recommendation: 6 Chicago suburbs being the most visited by riders, in those suburbs where the offering of bikes and advertisement should take place:
Equipment Related Recommendation: since the members tend to use the bicycles for shorters period and faster travel times, introducing more electric bikes with better mileage and higher speed for members will keep the current members happy and spark interest for casual who need quick rides, not to forget it is less physical,environment friendly and also can help in having more riders to explore the other suburbs of the city
Looking forward to seeing you agian.